Delete tables
1) Select the 'Query' menu and select 'Delete'.
2) Do one of the following to add fields that are to be deleted from the tables to the query design grid:
a) To delete records from a single table or from multiple tables with a one-to-one relationship:
NOTE: In the query Design view, at the top of the window, if one end of a join between two tables has the infinity symbol, it is a one-to-many relationship. Otherwise, it is a one-to-one relationship.
1] From the field list for the table from which to delete records, drag the asterisk (*) to the query design grid. ('From' appears in the 'Delete' cell in the query design grid.)
2] Drag fields on which to set criteria to the query design grid. ('Where' appears in the 'Delete' cell in the query design grid.)
b) To delete records from multiple tables with a one-to-many relationship:
NOTE: In the query Design view, at the top of the window, if one end of a join between two tables has the infinity symbol, it is a one-to-many relationship. Otherwise, it is a one-to-one relationship.
1] From the field list for the table with the 'many' side of the relationship (contains records related to the primary table), drag the asterisk (*) to the query design grid. ('From' appears in the 'Delete' cell in the query design grid.)
2] From the field list for the primary table (with the 'one' side of the relationship), drag the fields on which to set criteria to the query design grid. ('Where' appears in the 'Delete' cell in the query design grid.)
3) Enter the desired criteria in the 'Criteria' row for the fields dragged to the query design grid in step 2)a)2] or step 2)b)2].
4) Do one of the following to run the query and delete the records:
NOTE: To stop a query after it has started, press CTRL+BREAK.
a) To delete the records from the single table for a table or one-to-one relationship:
1] Make sure Query Design view is open.
NOTE: If Datasheet view is open, select the 'View' menu and select 'Query Design'.
2] Select the 'Query' menu and select 'Run'. (The records are deleted.)
b) To delete the records from the 'many' table for a one-to-many relationship:
1] Make sure Query Design view is open.
NOTE: If Datasheet view is open, select the 'View' menu and select 'Query Design'.
2] Select the 'Query' menu and select 'Run'.
3] Select the field list for each related table.
4] Press DELETE.
5] Repeat steps 4)b)3] and 4)b)4] for each related table. (When finished, all of the records from the 'many' table will be deleted. Only the primary table and the fields on which to set criteria remain in the query.)
6] Select the 'Query' menu and select 'Run'. (The records from the 'one' table are deleted.)